<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>考试成绩</title>
</head>
<body>
ALTER TABLE `pk_city`
ADD COLUMN `school_count`  int(10) NULL DEFAULT 0 COMMENT '学校数量' AFTER `parentid`;
ALTER TABLE `sys_user`
ADD UNIQUE INDEX `username` (`user_name`) USING HASH ;
ALTER TABLE `sys_user`
ADD COLUMN `agent_id`  bigint(20) NULL DEFAULT 0 COMMENT '代理商id' AFTER `role_id`;

ALTER TABLE `pk_city`
ADD COLUMN `agent_count`  int(10) NULL DEFAULT 0 COMMENT '代理商数量' AFTER `school_count`;

ALTER TABLE `pk_class`
ADD COLUMN `class_admin`  bigint(20) NULL DEFAULT 0 COMMENT '班主任' AFTER `sumnjp`;

ALTER TABLE `pk_semester`
ADD COLUMN `njrs`  int(10)  NULL DEFAULT 0 COMMENT '年级人数' AFTER `add_time`;
ALTER TABLE `pk_semester`
ADD COLUMN `score`  text    NULL  COMMENT '班级总分人数'  ;

ALTER TABLE `pk_semester`
ADD COLUMN `max_score`  varchar(100)  NULL DEFAULT 0 COMMENT '最高分'  ;
ALTER TABLE `pk_semester`
ADD COLUMN `min_score`  varchar(100)  NULL DEFAULT 0 COMMENT '最低分'  ;
ALTER TABLE `pk_semester`
ADD COLUMN `avg_score`  varchar(100)  NULL DEFAULT 0 COMMENT '平均分'  ;
ALTER TABLE `pk_semester`
ADD COLUMN `semester_desc`  varchar(255)  NULL DEFAULT 0 COMMENT '考试描述'  ;


ALTER TABLE `pk_semester`
ADD COLUMN `njrs`  int(10)  NULL DEFAULT 0 COMMENT '年级人数' AFTER `add_time`;

ALTER TABLE `tb_answer`
ADD COLUMN `class_count`  int(10)  NULL DEFAULT 0 COMMENT '班级人数'  ;

ALTER TABLE `tb_score_range`
ADD COLUMN `class_count`  int(10)  NULL DEFAULT 0 COMMENT '班级人数';

ALTER TABLE `pk_school`
ADD COLUMN `agent_name`  varchar(255) NULL DEFAULT '' COMMENT '代理商名称' AFTER `agent`;



    <div class="teach">
        <div class="testCard">
            <div class="testCard-head">
                <span>考试时间</span>
               <!-- <p>{{time}}</p>-->
            </div>
            <div class="testCard-title" >16-17下学期高二期末考试</div>
            <div class="testCard-mid">
                <div><span style=" font-size: 60px;color: #DC1F0B;"> 32</span>人</div>
                <div><span style=" font-size: 60px;color: #DC1F0B;">89.26</span>分</div>
                <div><span style=" font-size: 60px;color:#DC1F0B;">106.0</span>分</div>
            </div>
            <div class="testCard-foot">
                <div>班级考试人数</div>
                <div>班级平均分</div>
                <div>班级最高分</div>
            </div>
            <div style="margin-top:85px;">
                <button type="button" onclick="fenxi()"> 学情分析</button>
            </div>
        </div>
		<div class="testCard">
            <div class="testCard-head">
                <span>考试时间</span>
               <!-- <p>{{time}}</p>-->
            </div>
            <div class="testCard-title" >16-17下学期高二期末考试</div>
            <div class="testCard-mid">
                <div><span style=" font-size: 60px;color: #DC1F0B;"> 32</span>人</div>
                <div><span style=" font-size: 60px;color: #DC1F0B;">89.26</span>分</div>
                <div><span style=" font-size: 60px;color:#DC1F0B;">106.0</span>分</div>
            </div>
            <div class="testCard-foot">
                <div>班级考试人数</div>
                <div>班级平均分</div>
                <div>班级最高分</div>
            </div>
            <div style="margin-top:85px;">
                <button type="button" onclick="fenxi()"> 学情分析</button>
            </div>
        </div>
		<div class="testCard">
            <div class="testCard-head">
                <span>考试时间</span>
               <!-- <p>{{time}}</p>-->
            </div>
            <div class="testCard-title" >16-17下学期高二期末考试</div>
            <div class="testCard-mid">
                <div><span style=" font-size: 60px;color: #DC1F0B;"> 32</span>人</div>
                <div><span style=" font-size: 60px;color: #DC1F0B;">89.26</span>分</div>
                <div><span style=" font-size: 60px;color:#DC1F0B;">106.0</span>分</div>
            </div>
            <div class="testCard-foot">
                <div>班级考试人数</div>
                <div>班级平均分</div>
                <div>班级最高分</div>
            </div>
            <div style="margin-top:85px;">
                <button type="button" onclick="fenxi()"> 学情分析</button>
            </div>
        </div>
		<div class="testCard">
            <div class="testCard-head">
                <span>考试时间</span>
               <!-- <p>{{time}}</p>-->
            </div>
            <div class="testCard-title" >16-17下学期高二期末考试</div>
            <div class="testCard-mid">
                <div><span style=" font-size: 60px;color: #DC1F0B;"> 32</span>人</div>
                <div><span style=" font-size: 60px;color: #DC1F0B;">89.26</span>分</div>
                <div><span style=" font-size: 60px;color:#DC1F0B;">106.0</span>分</div>
            </div>
            <div class="testCard-foot">
                <div>班级考试人数</div>
                <div>班级平均分</div>
                <div>班级最高分</div>
            </div>
            <div style="margin-top:85px;">
                <button type="button" onclick="fenxi()"> 学情分析</button>
            </div>
        </div>
        <div class="testCard">
            <div class="testCard-head">
                <span>考试时间</span>
                <!-- <p>{{time}}</p>-->
            </div>
            <div class="testCard-title" >16-17下学期高二期末考试</div>
            <div class="testCard-mid">
                <div><span style=" font-size: 60px;color: #DC1F0B;"> 32</span>人</div>
                <div><span style=" font-size: 60px;color: #DC1F0B;">89.26</span>分</div>
                <div><span style=" font-size: 60px;color:#DC1F0B;">106.0</span>分</div>
            </div>
            <div class="testCard-foot">
                <div>班级考试人数</div>
                <div>班级平均分</div>
                <div>班级最高分</div>
            </div>
            <div style="margin-top:85px;">
                <button type="button" onclick="fenxi()"> 学情分析</button>
            </div>
        </div>
</body>
<style type="text/css">
    body {
        background-color: #F3F3EB;
    }
    .testCard{
        text-align: center;height:600px;border: 1px solid #CBD3D8; margin: 40px 50px 0px 50px;background-color: #fff;
        box-shadow: -13px 15px 17px #CBD3D8;    border-radius: 50px;
    }
    .testCard-head{
        text-align: left;padding: 15px 30px 15px 15px;width: 120px;background-color: #ECF3F8;border-radius: 0px 20px 20px 0px;
        color: #4F8BC8;margin-top: 40px;font-size: 30px;margin-bottom: 15px;
    }
    .testCard-title{
        font-size: 40px;
    }
    .testCard-mid{
        margin-top: 58px;
    }
    .testCard-mid div{
        width: 32%; font-size: 25px;color: #797D87;
        text-align: center;display: inline-block;
    }
    .testCard-foot div{
        width: 32%;font-size: 25px;margin-top: 10px;   color: #797D87;
        text-align: center;display: inline-block;
    }
    button{
        width: 70%;border-radius: 40px;background-color:#5089CC;font-size: 30px;text-align: center;
        display: inline-block;color: #fff;padding: 20px 0px 20px 0px;box-shadow: 0px 0px 45px #A7E0FF;
    }
</style>
</html>
